SORTING: EDITYPE now offers sorting. Choose SORT, and you are presented with a default data file. Choose LIST to see others. Choose the file you want to sort from the list by running the highlight bar to the file of choice. (Use mouse or keyboard...) Press ENTER or choose OK. This file will now be read in. Next you are presented with a list of the FIELDS to sort with. Choose the field from the listbox. Text fields are sorted such that you will find lower alphabetic characters in the file beginning. (Sorts a - z.) What this means is that "chair" will be in a lower record number than "widget." Example: telescope / moose / widget / chair / horse is sorted like: chair / horse / moose / telescope / widget Numeric fields are sorted for ascending order. Remember that you can sort a DATA file by ONLY one type of information. If you want things in alphabetic order by TYPE, for instance, in the ANTIQUES (sample) datafile, you would choose the ANTIQUES file and choose TYPE from the listbox. The file size and degree it needs sorting will determine the time taken. A couple of lines of text appear beneath the sort button to let you know it's working. Of course, the sample files take about 1/5th of a second, so you'll hardly notice the text... TYPE EDITING: The TYPE editor allows you to add or change a TYPE of collection. In this manner (using EDITYPE) you can augment or update the supplied samples or create your own templates for collections we never thought of... Collect! Addendum: Type Editor Pg 1 When you create data files that are used by Collect!, each is "keyed" to a collection type. This is the mechanism that allows you to OPEN the BOOKS data file and see the fields related to books on screen. The distribution floppy, for instance, comes with the following example data files: * Movies * Audio * Stamps * Antiques * Books * Programs * Coins * Guns * Jewelery Choose TYPE EDITOR. You will be asked for ADD NEW or EXISTING. ADD NEW: Creates a new collection type. BOTH: If an EXISTING type is to be edited, the current fields are shown in a window. If you're adding a NEW type, the same window appears with "DEFAULT" written in each of the places you can edit: the NAME of the Collection TYPE, and each of the 13 fields. Please note the rectangles next to each name. Click inside a rectangle to change this item. Also note the information to the right of the rectangle. This tells you what the expected type of information is for THAT field. Collect! Addendum: Type Editor Pg 2 Information Types: TEXT: alphanumeric information INTEGER: A whole number from -32000 to +32000 FLOATING: Decimal point number To edit the collection TYPE, just click somewhere in the box that contains the NAME of the collection type: TYPE <--------------- click here Field 1 [] Text Field 2 [] Text Field 3 [] Integer etc. When Collect! is up and running, the name of the collection type is put on the screen (Upper Left) for you. (TYPE) This entry allows you to name the database template what you wish. To the right of these names is the expected entry type. The entry type is fixed; be careful not to insert TEXT data in a field that would normally expect numeric data. Screen entries are limited in length by the editor (It doesn't want you to let the Collect! screen data overlap.) To EDIT a field name, simply click the corresponding field. Then, begin typing the new name. Press 'Enter' when done. You may wish to view a couple of included samples prior to creating a new collection type. After you have edited the fields, click the SAVE button. At this point you will then be able to edit the common spelling data file (PICK LIST) attached to field 4. Choices are: Add item Edit item Remove item DONE View Use VIEW to look at the list. Edit item will bring up the listbox for you to choose which item. Remove item does likewise. Choosing Add Item allows you to enter a NEW entry in the list. It is appended to the BOTTOM of the list. Adding or Editing works much the same as the Type Editor -- just type in the name and press ENTER. When you click DONE, the spelling pick list is saved to disk. You have now created/edited a collection type. Collect! Addendum: Type Editor Pg 3